Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
CustomerReferralRewardID (PK) | A token ID for a customer referral reward. | ID_CT_RFC_RWD | Identity | integer | |
CustomerRewardIssueDateTime | The date this CustomerReferralReward is issued and considered IN EFFECT. | DT_CT_RWD_ISS | AuditDateTime | datetime | |
CustomerReferralRewardExpirationDate | The date this CustomerReferralReward expires if not used by the customer. Note that this is important for accounting purposes. Technically a pending reward is a contingent liability and may be extingushed upon the customer's claim of a reward (at which time it becomes and expense) or expires (at which time it is purged). | DC_CT_RWD_EP | ExpirationDate | date | |
CustomerReferralRewardStatusCode | Code indicating the current status of tthe CustomerReferralReward. Valid values include: P - Pending - reward is issued C - Claimed (customer claims reward E - Expired, reward timed out and is nolonger claimable. | SC_CT_RWD | Code2Status | char(2) | |
RewardClaimDateTime | Date and time this CustomerReferralReward is claimed. | DT_RWD_CLM | AuditDateTime | datetime | |
CustomerReferralID (FK) | Token ID for a CustomerReferral | ID_CT_RFC | Identity | integer | CustomerReferral(CO_CT_RFC) |
Rewarded (FK) | The unique identifier for a promotion. | Rewarded | Identity | integer | PromotionalOffer(CO_PRM) |
PromotionalInitiativeID (FK) | A token ID for a retailer's PromotionInitiative instance. | ID_PRML_INITV | Identity | integer | PromotionalOffer(CO_PRM) |